Dataset statistics
| Number of variables | 32 |
|---|---|
| Number of observations | 6880 |
| Missing cells | 25125 |
| Missing cells (%) | 11.4% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.7 MiB |
| Average record size in memory | 256.0 B |
Variable types
| Categorical | 8 |
|---|---|
| Text | 11 |
| DateTime | 2 |
| Unsupported | 7 |
| Numeric | 4 |
ontime has constant value "G" | Constant |
delay has constant value "R" | Constant |
Driver_MobileNo is highly overall correlated with Market/Regular | High correlation |
Market/Regular is highly overall correlated with Driver_MobileNo and 2 other fields | High correlation |
Minimum_kms_to_be_covered_in_a_day is highly overall correlated with Market/Regular and 3 other fields | High correlation |
TRANSPORTATION_DISTANCE_IN_KM is highly overall correlated with customerID and 1 other fields | High correlation |
customerID is highly overall correlated with Minimum_kms_to_be_covered_in_a_day and 2 other fields | High correlation |
customerNameCode is highly overall correlated with Minimum_kms_to_be_covered_in_a_day and 3 other fields | High correlation |
vehicleType is highly overall correlated with Market/Regular and 2 other fields | High correlation |
GpsProvider is highly imbalanced (59.4%) | Imbalance |
Market/Regular is highly imbalanced (91.9%) | Imbalance |
Minimum_kms_to_be_covered_in_a_day is highly imbalanced (67.1%) | Imbalance |
customerID is highly imbalanced (54.2%) | Imbalance |
customerNameCode is highly imbalanced (53.9%) | Imbalance |
GpsProvider has 953 (13.9%) missing values | Missing |
Data_Ping_time has 953 (13.9%) missing values | Missing |
Current_Location has 964 (14.0%) missing values | Missing |
Curr_lat has 953 (13.9%) missing values | Missing |
Curr_lon has 953 (13.9%) missing values | Missing |
ontime has 4332 (63.0%) missing values | Missing |
delay has 2538 (36.9%) missing values | Missing |
trip_end_date has 194 (2.8%) missing values | Missing |
TRANSPORTATION_DISTANCE_IN_KM has 712 (10.3%) missing values | Missing |
vehicleType has 828 (12.0%) missing values | Missing |
Minimum_kms_to_be_covered_in_a_day has 4060 (59.0%) missing values | Missing |
Driver_Name has 3429 (49.8%) missing values | Missing |
Driver_MobileNo has 4189 (60.9%) missing values | Missing |
Planned_ETA is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
actual_eta is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
OriginLocation_Code is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
DestinationLocation_Code is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
trip_start_date is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
trip_end_date is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
supplierID is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2024-08-12 22:37:03.834123 |
|---|---|
| Analysis finished | 2024-08-12 22:37:12.792083 |
| Duration | 8.96 seconds |
| Software version | ydata-profiling vv4.9.0 |
| Download configuration | config.json |
GpsProvider
Categorical
IMBALANCE  MISSING 
| Distinct | 29 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 953 |
| Missing (%) | 13.9% |
| Memory size | 53.9 KiB |
| CONSENT TRACK | |
|---|---|
| VAMOSYS | |
| EKTA | 322 |
| JTECH | 241 |
| MANUAL | 219 |
| Other values (24) |
Length
| Max length | 22 |
|---|---|
| Median length | 13 |
| Mean length | 10.914122 |
| Min length | 4 |
Characters and Unicode
| Total characters | 64688 |
|---|---|
| Distinct characters | 42 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | CONSENT TRACK |
|---|---|
| 2nd row | VAMOSYS |
| 3rd row | CONSENT TRACK |
| 4th row | VAMOSYS |
| 5th row | VAMOSYS |
Common Values
| Value | Count | Frequency (%) |
| CONSENT TRACK | 3859 | |
| VAMOSYS | 788 | 11.5% |
| EKTA | 322 | 4.7% |
| JTECH | 241 | 3.5% |
| MANUAL | 219 | 3.2% |
| KRC LOGISTICS | 175 | 2.5% |
| WDSL | 72 | 1.0% |
| BEECON | 34 | 0.5% |
| NUEVASTECH | 29 | 0.4% |
| Garuda | 28 | 0.4% |
| Other values (19) | 160 | 2.3% |
| (Missing) | 953 | 13.9% |
Length
| Value | Count | Frequency (%) |
| consent | 3859 | |
| track | 3859 | |
| vamosys | 788 | 7.9% |
| ekta | 322 | 3.2% |
| jtech | 241 | 2.4% |
| manual | 219 | 2.2% |
| logistics | 188 | 1.9% |
| krc | 175 | 1.7% |
| wdsl | 72 | 0.7% |
| beecon | 34 | 0.3% |
| Other values (25) | 260 | 2.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 8639 | |
| C | 8488 | |
| N | 8079 | |
| S | 6069 | |
| A | 5629 | |
| O | 4964 | |
| E | 4639 | |
| K | 4369 | |
| R | 4132 | |
| 4090 | ||
| Other values (32) | 5590 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 64688 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| T | 8639 | |
| C | 8488 | |
| N | 8079 | |
| S | 6069 | |
| A | 5629 | |
| O | 4964 | |
| E | 4639 | |
| K | 4369 | |
| R | 4132 | |
| 4090 | ||
| Other values (32) | 5590 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 64688 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| T | 8639 | |
| C | 8488 | |
| N | 8079 | |
| S | 6069 | |
| A | 5629 | |
| O | 4964 | |
| E | 4639 | |
| K | 4369 | |
| R | 4132 | |
| 4090 | ||
| Other values (32) | 5590 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 64688 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| T | 8639 | |
| C | 8488 | |
| N | 8079 | |
| S | 6069 | |
| A | 5629 | |
| O | 4964 | |
| E | 4639 | |
| K | 4369 | |
| R | 4132 | |
| 4090 | ||
| Other values (32) | 5590 |
BookingID
Text
| Distinct | 6875 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.9 KiB |
Length
| Max length | 18 |
|---|---|
| Median length | 12 |
| Mean length | 12.722093 |
| Min length | 12 |
Characters and Unicode
| Total characters | 87528 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 6871 ? |
|---|---|
| Unique (%) | 99.9% |
Sample
| 1st row | MVCV0000927/082021 |
|---|---|
| 2nd row | VCV00014271/082021 |
| 3rd row | VCV00014382/082021 |
| 4th row | VCV00014743/082021 |
| 5th row | VCV00014744/082021 |
| Value | Count | Frequency (%) |
| mvcv0000798/082021 | 3 | < 0.1% |
| mvcv0000759/082021 | 2 | < 0.1% |
| vcv00014072/082021 | 2 | < 0.1% |
| aeibk1902026 | 2 | < 0.1% |
| vcv00014554/082021 | 1 | < 0.1% |
| vcv00014743/082021 | 1 | < 0.1% |
| vcv00014744/082021 | 1 | < 0.1% |
| vcv00014749/082021 | 1 | < 0.1% |
| vcv00014750/082021 | 1 | < 0.1% |
| vcv00014812/082021 | 1 | < 0.1% |
| Other values (6865) | 6865 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 11595 | |
| 2 | 9561 | 10.9% |
| 1 | 6531 | 7.5% |
| K | 6052 | 6.9% |
| B | 6052 | 6.9% |
| E | 4511 | 5.2% |
| A | 4511 | 5.2% |
| I | 4511 | 5.2% |
| 9 | 4121 | 4.7% |
| 4 | 3984 | 4.6% |
| Other values (14) | 26099 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 87528 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 11595 | |
| 2 | 9561 | 10.9% |
| 1 | 6531 | 7.5% |
| K | 6052 | 6.9% |
| B | 6052 | 6.9% |
| E | 4511 | 5.2% |
| A | 4511 | 5.2% |
| I | 4511 | 5.2% |
| 9 | 4121 | 4.7% |
| 4 | 3984 | 4.6% |
| Other values (14) | 26099 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 87528 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 11595 | |
| 2 | 9561 | 10.9% |
| 1 | 6531 | 7.5% |
| K | 6052 | 6.9% |
| B | 6052 | 6.9% |
| E | 4511 | 5.2% |
| A | 4511 | 5.2% |
| I | 4511 | 5.2% |
| 9 | 4121 | 4.7% |
| 4 | 3984 | 4.6% |
| Other values (14) | 26099 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 87528 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 11595 | |
| 2 | 9561 | 10.9% |
| 1 | 6531 | 7.5% |
| K | 6052 | 6.9% |
| B | 6052 | 6.9% |
| E | 4511 | 5.2% |
| A | 4511 | 5.2% |
| I | 4511 | 5.2% |
| 9 | 4121 | 4.7% |
| 4 | 3984 | 4.6% |
| Other values (14) | 26099 |
Market/Regular
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.9 KiB |
| Regular | |
|---|---|
| Market | 69 |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 6.9899709 |
| Min length | 6 |
Characters and Unicode
| Total characters | 48091 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Market |
|---|---|
| 2nd row | Regular |
| 3rd row | Regular |
| 4th row | Regular |
| 5th row | Regular |
Common Values
| Value | Count | Frequency (%) |
| Regular | 6811 | |
| Market | 69 | 1.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| regular | 6811 | |
| market | 69 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 6880 | |
| a | 6880 | |
| r | 6880 | |
| R | 6811 | |
| g | 6811 | |
| u | 6811 | |
| l | 6811 | |
| M | 69 | 0.1% |
| k | 69 | 0.1% |
| t | 69 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 48091 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 6880 | |
| a | 6880 | |
| r | 6880 | |
| R | 6811 | |
| g | 6811 | |
| u | 6811 | |
| l | 6811 | |
| M | 69 | 0.1% |
| k | 69 | 0.1% |
| t | 69 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 48091 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 6880 | |
| a | 6880 | |
| r | 6880 | |
| R | 6811 | |
| g | 6811 | |
| u | 6811 | |
| l | 6811 | |
| M | 69 | 0.1% |
| k | 69 | 0.1% |
| t | 69 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 48091 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 6880 | |
| a | 6880 | |
| r | 6880 | |
| R | 6811 | |
| g | 6811 | |
| u | 6811 | |
| l | 6811 | |
| M | 69 | 0.1% |
| k | 69 | 0.1% |
| t | 69 | 0.1% |
BookingID_Date
Date
| Distinct | 6005 |
|---|---|
| Distinct (%) | 87.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.9 KiB |
| Minimum | 2019-03-18 12:19:22 |
|---|---|
| Maximum | 2020-12-03 13:10:21 |
vehicle_no
Text
| Distinct | 2325 |
|---|---|
| Distinct (%) | 33.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.9 KiB |
Length
| Max length | 12 |
|---|---|
| Median length | 9 |
| Mean length | 9.4103198 |
| Min length | 7 |
Characters and Unicode
| Total characters | 64743 |
|---|---|
| Distinct characters | 46 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1381 ? |
|---|---|
| Unique (%) | 20.1% |
Sample
| 1st row | KA590408 |
|---|---|
| 2nd row | TN30BC5917 |
| 3rd row | TN22AR2748 |
| 4th row | TN28AQ0781 |
| 5th row | TN68F1722 |
| Value | Count | Frequency (%) |
| ts15uc9341 | 37 | 0.5% |
| ka01af0114 | 31 | 0.4% |
| ka21a5090 | 31 | 0.4% |
| ka21a3643 | 30 | 0.4% |
| ts15ud3698 | 29 | 0.4% |
| ka029324 | 28 | 0.4% |
| tn04ac4746 | 27 | 0.4% |
| ka219934 | 27 | 0.4% |
| ts15ud5174 | 26 | 0.4% |
| ts15ud3697 | 26 | 0.4% |
| Other values (2337) | 6624 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 6294 | 9.7% |
| 0 | 4759 | 7.4% |
| 4 | 4118 | 6.4% |
| 3 | 4052 | 6.3% |
| 5 | 4049 | 6.3% |
| 2 | 3811 | 5.9% |
| 8 | 3740 | 5.8% |
| 9 | 3582 | 5.5% |
| 7 | 3524 | 5.4% |
| 6 | 3343 | 5.2% |
| Other values (36) | 23471 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 64743 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 6294 | 9.7% |
| 0 | 4759 | 7.4% |
| 4 | 4118 | 6.4% |
| 3 | 4052 | 6.3% |
| 5 | 4049 | 6.3% |
| 2 | 3811 | 5.9% |
| 8 | 3740 | 5.8% |
| 9 | 3582 | 5.5% |
| 7 | 3524 | 5.4% |
| 6 | 3343 | 5.2% |
| Other values (36) | 23471 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 64743 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 6294 | 9.7% |
| 0 | 4759 | 7.4% |
| 4 | 4118 | 6.4% |
| 3 | 4052 | 6.3% |
| 5 | 4049 | 6.3% |
| 2 | 3811 | 5.9% |
| 8 | 3740 | 5.8% |
| 9 | 3582 | 5.5% |
| 7 | 3524 | 5.4% |
| 6 | 3343 | 5.2% |
| Other values (36) | 23471 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 64743 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 6294 | 9.7% |
| 0 | 4759 | 7.4% |
| 4 | 4118 | 6.4% |
| 3 | 4052 | 6.3% |
| 5 | 4049 | 6.3% |
| 2 | 3811 | 5.9% |
| 8 | 3740 | 5.8% |
| 9 | 3582 | 5.5% |
| 7 | 3524 | 5.4% |
| 6 | 3343 | 5.2% |
| Other values (36) | 23471 |
Origin_Location
Text
| Distinct | 180 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.9 KiB |
Length
| Max length | 56 |
|---|---|
| Median length | 46 |
| Mean length | 33.112355 |
| Min length | 16 |
Characters and Unicode
| Total characters | 227813 |
|---|---|
| Distinct characters | 61 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 41 ? |
|---|---|
| Unique (%) | 0.6% |
Sample
| 1st row | TVSLSL-PUZHAL-HUB,CHENNAI,TAMIL NADU |
|---|---|
| 2nd row | DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU |
| 3rd row | LUCAS TVS LTD-PONDY,PONDY,PONDICHERRY |
| 4th row | DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU |
| 5th row | LUCAS TVS LTD-PONDY,PONDY,PONDICHERRY |
| Value | Count | Frequency (%) |
| nadu | 1669 | 6.4% |
| tamil | 1181 | 4.5% |
| karnataka | 931 | 3.6% |
| bangalore | 927 | 3.6% |
| india | 877 | 3.4% |
| maharashtra | 701 | 2.7% |
| mugabala | 572 | 2.2% |
| rural | 572 | 2.2% |
| kanchipuram | 557 | 2.1% |
| gujarat | 476 | 1.8% |
| Other values (324) | 17537 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 35802 | 15.7% |
| 19120 | 8.4% | |
| , | 13349 | 5.9% |
| r | 13281 | 5.8% |
| n | 8867 | 3.9% |
| l | 8748 | 3.8% |
| u | 7961 | 3.5% |
| i | 7801 | 3.4% |
| e | 7344 | 3.2% |
| h | 7316 | 3.2% |
| Other values (51) | 98224 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 227813 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 35802 | 15.7% |
| 19120 | 8.4% | |
| , | 13349 | 5.9% |
| r | 13281 | 5.8% |
| n | 8867 | 3.9% |
| l | 8748 | 3.8% |
| u | 7961 | 3.5% |
| i | 7801 | 3.4% |
| e | 7344 | 3.2% |
| h | 7316 | 3.2% |
| Other values (51) | 98224 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 227813 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 35802 | 15.7% |
| 19120 | 8.4% | |
| , | 13349 | 5.9% |
| r | 13281 | 5.8% |
| n | 8867 | 3.9% |
| l | 8748 | 3.8% |
| u | 7961 | 3.5% |
| i | 7801 | 3.4% |
| e | 7344 | 3.2% |
| h | 7316 | 3.2% |
| Other values (51) | 98224 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 227813 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 35802 | 15.7% |
| 19120 | 8.4% | |
| , | 13349 | 5.9% |
| r | 13281 | 5.8% |
| n | 8867 | 3.9% |
| l | 8748 | 3.8% |
| u | 7961 | 3.5% |
| i | 7801 | 3.4% |
| e | 7344 | 3.2% |
| h | 7316 | 3.2% |
| Other values (51) | 98224 |
| Distinct | 520 |
|---|---|
| Distinct (%) | 7.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.9 KiB |
Length
| Max length | 58 |
|---|---|
| Median length | 49 |
| Mean length | 34.14157 |
| Min length | 10 |
Characters and Unicode
| Total characters | 234894 |
|---|---|
| Distinct characters | 65 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 175 ? |
|---|---|
| Unique (%) | 2.5% |
Sample
| 1st row | ASHOK LEYLAND PLANT 1- HOSUR,HOSUR,KARNATAKA |
|---|---|
| 2nd row | DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU |
| 3rd row | LUCAS TVS LTD-PONDY,PONDY,PONDICHERRY |
| 4th row | DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU |
| 5th row | LUCAS TVS LTD-PONDY,PONDY,PONDICHERRY |
| Value | Count | Frequency (%) |
| nadu | 1719 | 6.5% |
| tamil | 1238 | 4.7% |
| bangalore | 1047 | 3.9% |
| india | 878 | 3.3% |
| karnataka | 857 | 3.2% |
| kanchipuram | 648 | 2.4% |
| west | 595 | 2.2% |
| gujarat | 499 | 1.9% |
| haryana | 496 | 1.9% |
| delhi | 462 | 1.7% |
| Other values (834) | 18073 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 35110 | 14.9% |
| 19632 | 8.4% | |
| r | 13936 | 5.9% |
| , | 13768 | 5.9% |
| n | 11253 | 4.8% |
| i | 9260 | 3.9% |
| l | 7698 | 3.3% |
| h | 7694 | 3.3% |
| e | 7394 | 3.1% |
| d | 7373 | 3.1% |
| Other values (55) | 101776 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 234894 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 35110 | 14.9% |
| 19632 | 8.4% | |
| r | 13936 | 5.9% |
| , | 13768 | 5.9% |
| n | 11253 | 4.8% |
| i | 9260 | 3.9% |
| l | 7698 | 3.3% |
| h | 7694 | 3.3% |
| e | 7394 | 3.1% |
| d | 7373 | 3.1% |
| Other values (55) | 101776 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 234894 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 35110 | 14.9% |
| 19632 | 8.4% | |
| r | 13936 | 5.9% |
| , | 13768 | 5.9% |
| n | 11253 | 4.8% |
| i | 9260 | 3.9% |
| l | 7698 | 3.3% |
| h | 7694 | 3.3% |
| e | 7394 | 3.1% |
| d | 7373 | 3.1% |
| Other values (55) | 101776 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 234894 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 35110 | 14.9% |
| 19632 | 8.4% | |
| r | 13936 | 5.9% |
| , | 13768 | 5.9% |
| n | 11253 | 4.8% |
| i | 9260 | 3.9% |
| l | 7698 | 3.3% |
| h | 7694 | 3.3% |
| e | 7394 | 3.1% |
| d | 7373 | 3.1% |
| Other values (55) | 101776 |
Org_lat_lon
Text
| Distinct | 173 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.9 KiB |
Length
| Max length | 37 |
|---|---|
| Median length | 36 |
| Mean length | 25.484448 |
| Min length | 15 |
Characters and Unicode
| Total characters | 175333 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 40 ? |
|---|---|
| Unique (%) | 0.6% |
Sample
| 1st row | 13.1550,80.1960 |
|---|---|
| 2nd row | 12.8390,79.9540 |
| 3rd row | 11.8710,79.7390 |
| 4th row | 12.8390,79.9540 |
| 5th row | 11.8720,79.6320 |
| Value | Count | Frequency (%) |
| 16.560192249175344,80.792293091599547 | 1189 | 17.3% |
| 18.750621,73.87719 | 428 | 6.2% |
| 12.0001,79.74839949999999 | 409 | 5.9% |
| 26.192290403509681,91.751276775362513 | 380 | 5.5% |
| 12.8390,79.9540 | 342 | 5.0% |
| 28.373519,76.835337 | 254 | 3.7% |
| 22.961777,72.094219 | 217 | 3.2% |
| 23.525267916088961,87.264424348570884 | 214 | 3.1% |
| 13.007503209603689,77.665098855934886 | 199 | 2.9% |
| 12.992699792116747,77.803841411108593 | 161 | 2.3% |
| Other values (163) | 3087 |
Most occurring characters
| Value | Count | Frequency (%) |
| 9 | 22674 | |
| 7 | 19682 | |
| 1 | 18676 | |
| 2 | 17607 | |
| . | 13760 | |
| 0 | 13673 | |
| 8 | 13167 | |
| 5 | 13038 | |
| 3 | 12428 | |
| 6 | 12024 | |
| Other values (2) | 18604 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 175333 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 9 | 22674 | |
| 7 | 19682 | |
| 1 | 18676 | |
| 2 | 17607 | |
| . | 13760 | |
| 0 | 13673 | |
| 8 | 13167 | |
| 5 | 13038 | |
| 3 | 12428 | |
| 6 | 12024 | |
| Other values (2) | 18604 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 175333 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 9 | 22674 | |
| 7 | 19682 | |
| 1 | 18676 | |
| 2 | 17607 | |
| . | 13760 | |
| 0 | 13673 | |
| 8 | 13167 | |
| 5 | 13038 | |
| 3 | 12428 | |
| 6 | 12024 | |
| Other values (2) | 18604 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 175333 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 9 | 22674 | |
| 7 | 19682 | |
| 1 | 18676 | |
| 2 | 17607 | |
| . | 13760 | |
| 0 | 13673 | |
| 8 | 13167 | |
| 5 | 13038 | |
| 3 | 12428 | |
| 6 | 12024 | |
| Other values (2) | 18604 |
Des_lat_lon
Text
| Distinct | 522 |
|---|---|
| Distinct (%) | 7.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.9 KiB |
Length
| Max length | 37 |
|---|---|
| Median length | 36 |
| Mean length | 22.238663 |
| Min length | 14 |
Characters and Unicode
| Total characters | 153002 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 178 ? |
|---|---|
| Unique (%) | 2.6% |
Sample
| 1st row | 12.7400,77.8200 |
|---|---|
| 2nd row | 12.8390,79.9540 |
| 3rd row | 11.8710,79.7390 |
| 4th row | 12.8390,79.9540 |
| 5th row | 11.8720,79.6320 |
| Value | Count | Frequency (%) |
| 12.8390,79.9540 | 342 | 5.0% |
| 12.786517,79.975221 | 252 | 3.7% |
| 13.199089183304451,77.708554234959038 | 227 | 3.3% |
| 12.930429,79.931163 | 209 | 3.0% |
| 22.961777,72.094219 | 182 | 2.6% |
| 18.750621,73.87719 | 180 | 2.6% |
| 28.373519,76.835337 | 171 | 2.5% |
| 22.95210237429815,88.457014796076109 | 124 | 1.8% |
| 12.843107191355518,77.5942828776749 | 123 | 1.8% |
| 12.777874729699617,77.642275537347089 | 114 | 1.7% |
| Other values (512) | 4956 |
Most occurring characters
| Value | Count | Frequency (%) |
| 7 | 19782 | |
| 2 | 16536 | |
| 9 | 14877 | |
| 1 | 14763 | |
| . | 13760 | |
| 8 | 13191 | |
| 3 | 11759 | |
| 0 | 10936 | |
| 6 | 10426 | |
| 5 | 10093 | |
| Other values (2) | 16879 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 153002 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 7 | 19782 | |
| 2 | 16536 | |
| 9 | 14877 | |
| 1 | 14763 | |
| . | 13760 | |
| 8 | 13191 | |
| 3 | 11759 | |
| 0 | 10936 | |
| 6 | 10426 | |
| 5 | 10093 | |
| Other values (2) | 16879 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 153002 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 7 | 19782 | |
| 2 | 16536 | |
| 9 | 14877 | |
| 1 | 14763 | |
| . | 13760 | |
| 8 | 13191 | |
| 3 | 11759 | |
| 0 | 10936 | |
| 6 | 10426 | |
| 5 | 10093 | |
| Other values (2) | 16879 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 153002 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 7 | 19782 | |
| 2 | 16536 | |
| 9 | 14877 | |
| 1 | 14763 | |
| . | 13760 | |
| 8 | 13191 | |
| 3 | 11759 | |
| 0 | 10936 | |
| 6 | 10426 | |
| 5 | 10093 | |
| Other values (2) | 16879 |
Data_Ping_time
Date
MISSING 
| Distinct | 3756 |
|---|---|
| Distinct (%) | 63.4% |
| Missing | 953 |
| Missing (%) | 13.9% |
| Memory size | 53.9 KiB |
| Minimum | 2019-06-07 18:25:10 |
|---|---|
| Maximum | 2020-08-28 12:40:31 |
Planned_ETA
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 53.9 KiB |
Current_Location
Text
MISSING 
| Distinct | 2567 |
|---|---|
| Distinct (%) | 43.4% |
| Missing | 964 |
| Missing (%) | 14.0% |
| Memory size | 53.9 KiB |
Length
| Max length | 241 |
|---|---|
| Median length | 138 |
| Mean length | 67.408384 |
| Min length | 11 |
Characters and Unicode
| Total characters | 398788 |
|---|---|
| Distinct characters | 79 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1745 ? |
|---|---|
| Unique (%) | 29.5% |
Sample
| 1st row | Vaniyambadi Rd, Valayambattu, Tamil Nadu 635752, India |
|---|---|
| 2nd row | Unnamed Road, Oragadam Industrial Corridor, Vattambakkam R.F., Tamil Nadu 631605, India |
| 3rd row | 570, National Hwy 48, Shenoy Nagar, Chennai, Tamil Nadu 600030, India |
| 4th row | Singaperumal Koil - Sriperumbudur Rd, Oragadam Industrial Corridor, Vattambakkam R.F., Tamil Nadu 631605, India |
| 5th row | Melmaruvathur, Tamil Nadu 603319, India |
| Value | Count | Frequency (%) |
| india | 5927 | 10.7% |
| rd | 1843 | 3.3% |
| road | 1786 | 3.2% |
| tamil | 1614 | 2.9% |
| nadu | 1614 | 2.9% |
| unnamed | 1455 | 2.6% |
| 933 | 1.7% | |
| nagar | 867 | 1.6% |
| karnataka | 787 | 1.4% |
| industrial | 782 | 1.4% |
| Other values (5625) | 37564 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 53279 | 13.4% |
| 49256 | 12.4% | |
| , | 24109 | 6.0% |
| n | 20265 | 5.1% |
| d | 19957 | 5.0% |
| i | 19051 | 4.8% |
| r | 17828 | 4.5% |
| l | 11543 | 2.9% |
| e | 11328 | 2.8% |
| t | 10720 | 2.7% |
| Other values (69) | 161452 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 398788 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 53279 | 13.4% |
| 49256 | 12.4% | |
| , | 24109 | 6.0% |
| n | 20265 | 5.1% |
| d | 19957 | 5.0% |
| i | 19051 | 4.8% |
| r | 17828 | 4.5% |
| l | 11543 | 2.9% |
| e | 11328 | 2.8% |
| t | 10720 | 2.7% |
| Other values (69) | 161452 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 398788 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 53279 | 13.4% |
| 49256 | 12.4% | |
| , | 24109 | 6.0% |
| n | 20265 | 5.1% |
| d | 19957 | 5.0% |
| i | 19051 | 4.8% |
| r | 17828 | 4.5% |
| l | 11543 | 2.9% |
| e | 11328 | 2.8% |
| t | 10720 | 2.7% |
| Other values (69) | 161452 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 398788 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 53279 | 13.4% |
| 49256 | 12.4% | |
| , | 24109 | 6.0% |
| n | 20265 | 5.1% |
| d | 19957 | 5.0% |
| i | 19051 | 4.8% |
| r | 17828 | 4.5% |
| l | 11543 | 2.9% |
| e | 11328 | 2.8% |
| t | 10720 | 2.7% |
| Other values (69) | 161452 |
| Distinct | 520 |
|---|---|
| Distinct (%) | 7.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.9 KiB |
Length
| Max length | 58 |
|---|---|
| Median length | 49 |
| Mean length | 34.14157 |
| Min length | 10 |
Characters and Unicode
| Total characters | 234894 |
|---|---|
| Distinct characters | 65 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 175 ? |
|---|---|
| Unique (%) | 2.5% |
Sample
| 1st row | ASHOK LEYLAND PLANT 1- HOSUR,HOSUR,KARNATAKA |
|---|---|
| 2nd row | DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU |
| 3rd row | LUCAS TVS LTD-PONDY,PONDY,PONDICHERRY |
| 4th row | DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU |
| 5th row | LUCAS TVS LTD-PONDY,PONDY,PONDICHERRY |
| Value | Count | Frequency (%) |
| nadu | 1719 | 6.5% |
| tamil | 1238 | 4.7% |
| bangalore | 1047 | 3.9% |
| india | 878 | 3.3% |
| karnataka | 857 | 3.2% |
| kanchipuram | 648 | 2.4% |
| west | 595 | 2.2% |
| gujarat | 499 | 1.9% |
| haryana | 496 | 1.9% |
| delhi | 462 | 1.7% |
| Other values (834) | 18073 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 35110 | 14.9% |
| 19632 | 8.4% | |
| r | 13936 | 5.9% |
| , | 13768 | 5.9% |
| n | 11253 | 4.8% |
| i | 9260 | 3.9% |
| l | 7698 | 3.3% |
| h | 7694 | 3.3% |
| e | 7394 | 3.1% |
| d | 7373 | 3.1% |
| Other values (55) | 101776 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 234894 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 35110 | 14.9% |
| 19632 | 8.4% | |
| r | 13936 | 5.9% |
| , | 13768 | 5.9% |
| n | 11253 | 4.8% |
| i | 9260 | 3.9% |
| l | 7698 | 3.3% |
| h | 7694 | 3.3% |
| e | 7394 | 3.1% |
| d | 7373 | 3.1% |
| Other values (55) | 101776 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 234894 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 35110 | 14.9% |
| 19632 | 8.4% | |
| r | 13936 | 5.9% |
| , | 13768 | 5.9% |
| n | 11253 | 4.8% |
| i | 9260 | 3.9% |
| l | 7698 | 3.3% |
| h | 7694 | 3.3% |
| e | 7394 | 3.1% |
| d | 7373 | 3.1% |
| Other values (55) | 101776 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 234894 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 35110 | 14.9% |
| 19632 | 8.4% | |
| r | 13936 | 5.9% |
| , | 13768 | 5.9% |
| n | 11253 | 4.8% |
| i | 9260 | 3.9% |
| l | 7698 | 3.3% |
| h | 7694 | 3.3% |
| e | 7394 | 3.1% |
| d | 7373 | 3.1% |
| Other values (55) | 101776 |
actual_eta
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 37 |
|---|---|
| Missing (%) | 0.5% |
| Memory size | 53.9 KiB |
Curr_lat
Real number (ℝ)
MISSING 
| Distinct | 4139 |
|---|---|
| Distinct (%) | 69.8% |
| Missing | 953 |
| Missing (%) | 13.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.679995 |
| Minimum | 8.16679 |
|---|---|
| Maximum | 32.367928 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 53.9 KiB |
Quantile statistics
| Minimum | 8.16679 |
|---|---|
| 5-th percentile | 12.485942 |
| Q1 | 12.871868 |
| median | 17.470922 |
| Q3 | 23.202009 |
| 95-th percentile | 28.536316 |
| Maximum | 32.367928 |
| Range | 24.201138 |
| Interquartile range (IQR) | 10.330141 |
Descriptive statistics
| Standard deviation | 6.0755609 |
|---|---|
| Coefficient of variation (CV) | 0.32524425 |
| Kurtosis | -1.3083293 |
| Mean | 18.679995 |
| Median Absolute Deviation (MAD) | 4.6892575 |
| Skewness | 0.40896195 |
| Sum | 110716.33 |
| Variance | 36.91244 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 17.46342 | 33 | 0.5% |
| 17.4709225 | 21 | 0.3% |
| 19.032803 | 20 | 0.3% |
| 13.166807 | 18 | 0.3% |
| 13.19702 | 16 | 0.2% |
| 28.20895 | 16 | 0.2% |
| 12.781673 | 15 | 0.2% |
| 13.1191355 | 14 | 0.2% |
| 13.199137 | 13 | 0.2% |
| 28.52547 | 13 | 0.2% |
| Other values (4129) | 5748 | |
| (Missing) | 953 | 13.9% |
| Value | Count | Frequency (%) |
| 8.16679 | 1 | |
| 8.194479 | 1 | |
| 8.70089 | 1 | |
| 8.7388 | 1 | |
| 8.784697 | 1 | |
| 8.81781 | 1 | |
| 8.912319 | 1 | |
| 9.061639444 | 1 | |
| 9.369471 | 1 | |
| 9.483545 | 2 |
| Value | Count | Frequency (%) |
| 32.367928 | 1 | |
| 32.3675 | 1 | |
| 31.360373 | 1 | |
| 31.360283 | 1 | |
| 31.35795222 | 1 | |
| 31.34324 | 1 | |
| 31.337187 | 1 | |
| 31.33258 | 1 | |
| 31.33047583 | 1 | |
| 31.12698194 | 1 |
Curr_lon
Real number (ℝ)
MISSING 
| Distinct | 4109 |
|---|---|
| Distinct (%) | 69.3% |
| Missing | 953 |
| Missing (%) | 13.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 78.759745 |
| Minimum | 69.657698 |
|---|---|
| Maximum | 95.52955 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 53.9 KiB |
Quantile statistics
| Minimum | 69.657698 |
|---|---|
| 5-th percentile | 72.414279 |
| Q1 | 76.891857 |
| median | 77.84334 |
| Q3 | 80.018999 |
| 95-th percentile | 88.27194 |
| Maximum | 95.52955 |
| Range | 25.871852 |
| Interquartile range (IQR) | 3.127142 |
Descriptive statistics
| Standard deviation | 4.2163571 |
|---|---|
| Coefficient of variation (CV) | 0.053534417 |
| Kurtosis | 1.2433644 |
| Mean | 78.759745 |
| Median Absolute Deviation (MAD) | 2.1070778 |
| Skewness | 0.96375247 |
| Sum | 466809.01 |
| Variance | 17.777667 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 78.19776 | 33 | 0.5% |
| 78.22128306 | 21 | 0.3% |
| 73.1012153 | 20 | 0.3% |
| 80.29405 | 18 | 0.3% |
| 77.71069 | 16 | 0.2% |
| 77.30532 | 16 | 0.2% |
| 80.01655 | 15 | 0.2% |
| 77.8888891 | 14 | 0.2% |
| 77.28333 | 13 | 0.2% |
| 77.711136 | 13 | 0.2% |
| Other values (4099) | 5748 | |
| (Missing) | 953 | 13.9% |
| Value | Count | Frequency (%) |
| 69.65769778 | 1 | < 0.1% |
| 69.8644 | 1 | < 0.1% |
| 70.06671 | 1 | < 0.1% |
| 70.098045 | 1 | < 0.1% |
| 70.11327 | 1 | < 0.1% |
| 70.5046 | 1 | < 0.1% |
| 70.83222639 | 1 | < 0.1% |
| 71.45707361 | 1 | < 0.1% |
| 71.97328083 | 1 | < 0.1% |
| 71.97397667 | 5 |
| Value | Count | Frequency (%) |
| 95.52955 | 1 | |
| 94.94118694 | 1 | |
| 94.91118917 | 1 | |
| 94.88311 | 1 | |
| 94.45472 | 1 | |
| 94.20018 | 1 | |
| 94.19761417 | 1 | |
| 93.74356972 | 1 | |
| 92.79803 | 1 | |
| 92.79426111 | 1 |
ontime
Categorical
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 4332 |
| Missing (%) | 63.0% |
| Memory size | 53.9 KiB |
| G |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 2548 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | G |
|---|---|
| 2nd row | G |
| 3rd row | G |
| 4th row | G |
| 5th row | G |
Common Values
| Value | Count | Frequency (%) |
| G | 2548 | |
| (Missing) | 4332 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| g | 2548 |
Most occurring characters
| Value | Count | Frequency (%) |
| G | 2548 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2548 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| G | 2548 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2548 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| G | 2548 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2548 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| G | 2548 |
delay
Categorical
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2538 |
| Missing (%) | 36.9% |
| Memory size | 53.9 KiB |
| R |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 4342 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | R |
|---|---|
| 2nd row | R |
| 3rd row | R |
| 4th row | R |
| 5th row | R |
Common Values
| Value | Count | Frequency (%) |
| R | 4342 | |
| (Missing) | 2538 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| r | 4342 |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 4342 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4342 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| R | 4342 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4342 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| R | 4342 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4342 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| R | 4342 |
OriginLocation_Code
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 3 |
|---|---|
| Missing (%) | < 0.1% |
| Memory size | 53.9 KiB |
DestinationLocation_Code
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 27 |
|---|---|
| Missing (%) | 0.4% |
| Memory size | 53.9 KiB |
trip_start_date
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 53.9 KiB |
trip_end_date
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 194 |
|---|---|
| Missing (%) | 2.8% |
| Memory size | 53.9 KiB |
TRANSPORTATION_DISTANCE_IN_KM
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 564 |
|---|---|
| Distinct (%) | 9.1% |
| Missing | 712 |
| Missing (%) | 10.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 553.85628 |
| Minimum | 0 |
|---|---|
| Maximum | 2954.7 |
| Zeros | 18 |
| Zeros (%) | 0.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 53.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 20 |
| Q1 | 40 |
| median | 160 |
| Q3 | 900 |
| 95-th percentile | 2400 |
| Maximum | 2954.7 |
| Range | 2954.7 |
| Interquartile range (IQR) | 860 |
Descriptive statistics
| Standard deviation | 758.98184 |
|---|---|
| Coefficient of variation (CV) | 1.3703588 |
| Kurtosis | 0.8988935 |
| Mean | 553.85628 |
| Median Absolute Deviation (MAD) | 135 |
| Skewness | 1.4730875 |
| Sum | 3416185.5 |
| Variance | 576053.43 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 25 | 384 | 5.6% |
| 30 | 227 | 3.3% |
| 1900 | 201 | 2.9% |
| 40 | 180 | 2.6% |
| 70 | 177 | 2.6% |
| 49 | 143 | 2.1% |
| 1290 | 137 | 2.0% |
| 2425 | 132 | 1.9% |
| 31 | 122 | 1.8% |
| 1199 | 121 | 1.8% |
| Other values (554) | 4344 | |
| (Missing) | 712 | 10.3% |
| Value | Count | Frequency (%) |
| 0 | 18 | 0.3% |
| 3 | 46 | |
| 5 | 2 | < 0.1% |
| 7.6 | 5 | 0.1% |
| 8.2 | 3 | < 0.1% |
| 9.4 | 16 | 0.2% |
| 10 | 1 | < 0.1% |
| 10.2 | 2 | < 0.1% |
| 12 | 3 | < 0.1% |
| 12.8 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2954.7 | 1 | < 0.1% |
| 2898 | 1 | < 0.1% |
| 2884 | 1 | < 0.1% |
| 2800 | 2 | < 0.1% |
| 2750 | 29 | |
| 2723 | 2 | < 0.1% |
| 2710 | 1 | < 0.1% |
| 2704 | 1 | < 0.1% |
| 2700 | 33 | |
| 2681 | 1 | < 0.1% |
vehicleType
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 44 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 828 |
| Missing (%) | 12.0% |
| Memory size | 53.9 KiB |
| 40 FT 3XL Trailer 35MT | |
|---|---|
| 32 FT Multi-Axle 14MT - HCV | |
| 40 FT Flat Bed Multi-Axle 27MT - Trailer | |
| 32 FT Single-Axle 7MT - HCV | |
| 28 FT Open Body 25MT | 171 |
| Other values (39) |
Length
| Max length | 47 |
|---|---|
| Median length | 41 |
| Mean length | 26.392102 |
| Min length | 15 |
Characters and Unicode
| Total characters | 159725 |
|---|---|
| Distinct characters | 53 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 6 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 32 FT Single-Axle 7MT - HCV |
|---|---|
| 2nd row | 32 FT Multi-Axle 14MT - HCV |
| 3rd row | 1 MT Tata Ace (Open Body) |
| 4th row | 32 FT Multi-Axle 14MT - HCV |
| 5th row | 32 FT Multi-Axle 14MT - HCV |
Common Values
| Value | Count | Frequency (%) |
| 40 FT 3XL Trailer 35MT | 2575 | |
| 32 FT Multi-Axle 14MT - HCV | 957 | 13.9% |
| 40 FT Flat Bed Multi-Axle 27MT - Trailer | 670 | 9.7% |
| 32 FT Single-Axle 7MT - HCV | 491 | 7.1% |
| 28 FT Open Body 25MT | 171 | 2.5% |
| 24 / 26 FT Taurus Open 21MT - HCV | 158 | 2.3% |
| 24 | 26 FT Taurus Open 21MT - HCV | 157 | 2.3% |
| 40 FT Flat Bed Double-Axle 21MT - Trailer | 152 | 2.2% |
| 22 FT Taurus Open 16MT - HCV | 133 | 1.9% |
| 19 FT Open 7MT - MCV | 111 | 1.6% |
| Other values (34) | 477 | 6.9% |
| (Missing) | 828 | 12.0% |
Length
| Value | Count | Frequency (%) |
| ft | 5977 | |
| trailer | 3404 | 9.5% |
| 40 | 3401 | 9.5% |
| 3244 | 9.0% | |
| 3xl | 2575 | 7.2% |
| 35mt | 2575 | 7.2% |
| hcv | 1933 | 5.4% |
| multi-axle | 1716 | 4.8% |
| 32 | 1543 | 4.3% |
| 14mt | 957 | 2.7% |
| Other values (60) | 8570 |
Most occurring characters
| Value | Count | Frequency (%) |
| 29880 | ||
| T | 15827 | 9.9% |
| l | 9045 | 5.7% |
| e | 8377 | 5.2% |
| M | 7940 | 5.0% |
| r | 7416 | 4.6% |
| F | 6804 | 4.3% |
| 3 | 6727 | 4.2% |
| i | 5862 | 3.7% |
| - | 5367 | 3.4% |
| Other values (43) | 56480 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 159725 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 29880 | ||
| T | 15827 | 9.9% |
| l | 9045 | 5.7% |
| e | 8377 | 5.2% |
| M | 7940 | 5.0% |
| r | 7416 | 4.6% |
| F | 6804 | 4.3% |
| 3 | 6727 | 4.2% |
| i | 5862 | 3.7% |
| - | 5367 | 3.4% |
| Other values (43) | 56480 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 159725 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 29880 | ||
| T | 15827 | 9.9% |
| l | 9045 | 5.7% |
| e | 8377 | 5.2% |
| M | 7940 | 5.0% |
| r | 7416 | 4.6% |
| F | 6804 | 4.3% |
| 3 | 6727 | 4.2% |
| i | 5862 | 3.7% |
| - | 5367 | 3.4% |
| Other values (43) | 56480 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 159725 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 29880 | ||
| T | 15827 | 9.9% |
| l | 9045 | 5.7% |
| e | 8377 | 5.2% |
| M | 7940 | 5.0% |
| r | 7416 | 4.6% |
| F | 6804 | 4.3% |
| 3 | 6727 | 4.2% |
| i | 5862 | 3.7% |
| - | 5367 | 3.4% |
| Other values (43) | 56480 |
Minimum_kms_to_be_covered_in_a_day
Categorical
HIGH CORRELATION  IMBALANCE  MISSING 
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 4060 |
| Missing (%) | 59.0% |
| Memory size | 53.9 KiB |
| 250.0 | |
|---|---|
| 275.0 | |
| 0.0 | 24 |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 4.9829787 |
| Min length | 3 |
Characters and Unicode
| Total characters | 14052 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 250.0 |
|---|---|
| 2nd row | 250.0 |
| 3rd row | 250.0 |
| 4th row | 250.0 |
| 5th row | 250.0 |
Common Values
| Value | Count | Frequency (%) |
| 250.0 | 2529 | |
| 275.0 | 267 | 3.9% |
| 0.0 | 24 | 0.3% |
| (Missing) | 4060 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 250.0 | 2529 | |
| 275.0 | 267 | 9.5% |
| 0.0 | 24 | 0.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 5373 | |
| . | 2820 | |
| 2 | 2796 | |
| 5 | 2796 | |
| 7 | 267 | 1.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 14052 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 5373 | |
| . | 2820 | |
| 2 | 2796 | |
| 5 | 2796 | |
| 7 | 267 | 1.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 14052 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 5373 | |
| . | 2820 | |
| 2 | 2796 | |
| 5 | 2796 | |
| 7 | 267 | 1.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 14052 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 5373 | |
| . | 2820 | |
| 2 | 2796 | |
| 5 | 2796 | |
| 7 | 267 | 1.9% |
Driver_Name
Text
MISSING 
| Distinct | 1355 |
|---|---|
| Distinct (%) | 39.3% |
| Missing | 3429 |
| Missing (%) | 49.8% |
| Memory size | 53.9 KiB |
Length
| Max length | 45 |
|---|---|
| Median length | 20 |
| Mean length | 10.064039 |
| Min length | 2 |
Characters and Unicode
| Total characters | 34731 |
|---|---|
| Distinct characters | 55 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 800 ? |
|---|---|
| Unique (%) | 23.2% |
Sample
| 1st row | RAMESH |
|---|---|
| 2nd row | GIRI |
| 3rd row | RAVI |
| 4th row | TAMIL |
| 5th row | GANESH |
| Value | Count | Frequency (%) |
| kumar | 353 | 6.0% |
| singh | 175 | 3.0% |
| khan | 169 | 2.9% |
| k | 83 | 1.4% |
| yadav | 76 | 1.3% |
| s | 66 | 1.1% |
| manu | 64 | 1.1% |
| n | 63 | 1.1% |
| r | 59 | 1.0% |
| m | 58 | 1.0% |
| Other values (1285) | 4712 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 5204 | 15.0% |
| 2485 | 7.2% | |
| R | 2116 | 6.1% |
| N | 2021 | 5.8% |
| S | 1781 | 5.1% |
| M | 1684 | 4.8% |
| H | 1601 | 4.6% |
| I | 1546 | 4.5% |
| a | 1443 | 4.2% |
| K | 1432 | 4.1% |
| Other values (45) | 13418 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 34731 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 5204 | 15.0% |
| 2485 | 7.2% | |
| R | 2116 | 6.1% |
| N | 2021 | 5.8% |
| S | 1781 | 5.1% |
| M | 1684 | 4.8% |
| H | 1601 | 4.6% |
| I | 1546 | 4.5% |
| a | 1443 | 4.2% |
| K | 1432 | 4.1% |
| Other values (45) | 13418 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 34731 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 5204 | 15.0% |
| 2485 | 7.2% | |
| R | 2116 | 6.1% |
| N | 2021 | 5.8% |
| S | 1781 | 5.1% |
| M | 1684 | 4.8% |
| H | 1601 | 4.6% |
| I | 1546 | 4.5% |
| a | 1443 | 4.2% |
| K | 1432 | 4.1% |
| Other values (45) | 13418 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 34731 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 5204 | 15.0% |
| 2485 | 7.2% | |
| R | 2116 | 6.1% |
| N | 2021 | 5.8% |
| S | 1781 | 5.1% |
| M | 1684 | 4.8% |
| H | 1601 | 4.6% |
| I | 1546 | 4.5% |
| a | 1443 | 4.2% |
| K | 1432 | 4.1% |
| Other values (45) | 13418 |
Driver_MobileNo
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 1273 |
|---|---|
| Distinct (%) | 47.3% |
| Missing | 4189 |
| Missing (%) | 60.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.5989813 × 109 |
| Minimum | 6.0005463 × 109 |
|---|---|
| Maximum | 1 × 1010 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 53.9 KiB |
Quantile statistics
| Minimum | 6.0005463 × 109 |
|---|---|
| 5-th percentile | 6.3837783 × 109 |
| Q1 | 7.6515046 × 109 |
| median | 8.9307619 × 109 |
| Q3 | 9.6349814 × 109 |
| 95-th percentile | 9.9521734 × 109 |
| Maximum | 1 × 1010 |
| Range | 3.9994537 × 109 |
| Interquartile range (IQR) | 1.9834768 × 109 |
Descriptive statistics
| Standard deviation | 1.1316687 × 109 |
|---|---|
| Coefficient of variation (CV) | 0.13160498 |
| Kurtosis | -1.019947 |
| Mean | 8.5989813 × 109 |
| Median Absolute Deviation (MAD) | 8.6022544 × 108 |
| Skewness | -0.5050876 |
| Sum | 2.3139859 × 1013 |
| Variance | 1.2806742 × 1018 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9952349318 | 28 | 0.4% |
| 7868857313 | 18 | 0.3% |
| 9600691019 | 18 | 0.3% |
| 7082423070 | 18 | 0.3% |
| 7082423058 | 17 | 0.2% |
| 9944446299 | 17 | 0.2% |
| 9952173355 | 16 | 0.2% |
| 9688429909 | 14 | 0.2% |
| 8015761413 | 14 | 0.2% |
| 8295883296 | 14 | 0.2% |
| Other values (1263) | 2517 | |
| (Missing) | 4189 |
| Value | Count | Frequency (%) |
| 6000546262 | 3 | |
| 6006291329 | 1 | < 0.1% |
| 6006450076 | 2 | |
| 6201157407 | 2 | |
| 6201982709 | 1 | < 0.1% |
| 6201994678 | 2 | |
| 6202125568 | 2 | |
| 6203975611 | 2 | |
| 6204355364 | 1 | < 0.1% |
| 6204621632 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 9999999999 | 7 | |
| 9999681295 | 3 | |
| 9999031538 | 2 | < 0.1% |
| 9998843103 | 1 | < 0.1% |
| 9997623277 | 1 | < 0.1% |
| 9997471510 | 1 | < 0.1% |
| 9997295833 | 2 | < 0.1% |
| 9996036863 | 1 | < 0.1% |
| 9994900412 | 1 | < 0.1% |
| 9994798323 | 2 | < 0.1% |
customerID
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 39 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.9 KiB |
| LTLEXMUM40 | |
|---|---|
| FILEXCHE19 | |
| DMREXCHEUX | |
| ALLEXCHE45 | 251 |
| LUTGCCHE06 | 222 |
| Other values (34) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 68800 |
|---|---|
| Distinct characters | 35 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 8 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | ALLEXCHE45 |
|---|---|
| 2nd row | DMREXCHEUX |
| 3rd row | LUTGCCHE06 |
| 4th row | DMREXCHEUX |
| 5th row | LUTGCCHE06 |
Common Values
| Value | Count | Frequency (%) |
| LTLEXMUM40 | 4092 | |
| FILEXCHE19 | 657 | 9.5% |
| DMREXCHEUX | 588 | 8.5% |
| ALLEXCHE45 | 251 | 3.6% |
| LUTGCCHE06 | 222 | 3.2% |
| ERCEXPUNTG | 211 | 3.1% |
| BILGCCHE02 | 161 | 2.3% |
| TMCGCCHE05 | 117 | 1.7% |
| OTIEXHOSJM | 108 | 1.6% |
| WENEXBAN18 | 78 | 1.1% |
| Other values (29) | 395 | 5.7% |
Length
| Value | Count | Frequency (%) |
| ltlexmum40 | 4092 | |
| filexche19 | 657 | 9.5% |
| dmrexcheux | 588 | 8.5% |
| allexche45 | 251 | 3.6% |
| lutgcche06 | 222 | 3.2% |
| ercexpuntg | 211 | 3.1% |
| bilgcche02 | 161 | 2.3% |
| tmcgcche05 | 117 | 1.7% |
| otiexhosjm | 108 | 1.6% |
| wenexban18 | 78 | 1.1% |
| Other values (29) | 395 | 5.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| L | 9780 | |
| M | 9144 | |
| E | 8789 | |
| X | 6906 | |
| U | 5347 | |
| T | 4957 | |
| 0 | 4657 | |
| 4 | 4429 | |
| C | 3067 | 4.5% |
| H | 2287 | 3.3% |
| Other values (25) | 9437 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 68800 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| L | 9780 | |
| M | 9144 | |
| E | 8789 | |
| X | 6906 | |
| U | 5347 | |
| T | 4957 | |
| 0 | 4657 | |
| 4 | 4429 | |
| C | 3067 | 4.5% |
| H | 2287 | 3.3% |
| Other values (25) | 9437 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 68800 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| L | 9780 | |
| M | 9144 | |
| E | 8789 | |
| X | 6906 | |
| U | 5347 | |
| T | 4957 | |
| 0 | 4657 | |
| 4 | 4429 | |
| C | 3067 | 4.5% |
| H | 2287 | 3.3% |
| Other values (25) | 9437 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 68800 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| L | 9780 | |
| M | 9144 | |
| E | 8789 | |
| X | 6906 | |
| U | 5347 | |
| T | 4957 | |
| 0 | 4657 | |
| 4 | 4429 | |
| C | 3067 | 4.5% |
| H | 2287 | 3.3% |
| Other values (25) | 9437 |
customerNameCode
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 39 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.9 KiB |
| Larsen & toubro limited | |
|---|---|
| Ford india private limited | |
| Daimler india commercial vehicles pvt lt | |
| Lucas tvs ltd | 222 |
| Ashok leyland limited | 211 |
| Other values (34) |
Length
| Max length | 40 |
|---|---|
| Median length | 23 |
| Mean length | 24.977762 |
| Min length | 13 |
Characters and Unicode
| Total characters | 171847 |
|---|---|
| Distinct characters | 49 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 8 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Ashok leyland limited |
|---|---|
| 2nd row | Daimler india commercial vehicles pvt lt |
| 3rd row | Lucas tvs ltd |
| 4th row | Daimler india commercial vehicles pvt lt |
| 5th row | Lucas tvs ltd |
Common Values
| Value | Count | Frequency (%) |
| Larsen & toubro limited | 4092 | |
| Ford india private limited | 657 | 9.5% |
| Daimler india commercial vehicles pvt lt | 588 | 8.5% |
| Lucas tvs ltd | 222 | 3.2% |
| Ashok leyland limited | 211 | 3.1% |
| Ericsson india private limited | 211 | 3.1% |
| Brakes india private ltd | 161 | 2.3% |
| Tvs motor company limited | 117 | 1.7% |
| Otis elevator company (india) ltd | 108 | 1.6% |
| Wipro enterprises pvt ltd | 78 | 1.1% |
| Other values (29) | 435 | 6.3% |
Length
| Value | Count | Frequency (%) |
| limited | 5496 | |
| 4116 | ||
| larsen | 4092 | |
| toubro | 4092 | |
| india | 1867 | 6.6% |
| private | 1126 | 4.0% |
| ltd | 782 | 2.8% |
| pvt | 743 | 2.6% |
| ford | 657 | 2.3% |
| daimler | 588 | 2.1% |
| Other values (69) | 4791 |
Most occurring characters
| Value | Count | Frequency (%) |
| 21470 | ||
| i | 18397 | |
| e | 14543 | 8.5% |
| t | 13890 | 8.1% |
| r | 12472 | 7.3% |
| o | 11103 | 6.5% |
| a | 9616 | 5.6% |
| l | 9335 | 5.4% |
| d | 9100 | 5.3% |
| m | 7886 | 4.6% |
| Other values (39) | 44035 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 171847 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 21470 | ||
| i | 18397 | |
| e | 14543 | 8.5% |
| t | 13890 | 8.1% |
| r | 12472 | 7.3% |
| o | 11103 | 6.5% |
| a | 9616 | 5.6% |
| l | 9335 | 5.4% |
| d | 9100 | 5.3% |
| m | 7886 | 4.6% |
| Other values (39) | 44035 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 171847 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 21470 | ||
| i | 18397 | |
| e | 14543 | 8.5% |
| t | 13890 | 8.1% |
| r | 12472 | 7.3% |
| o | 11103 | 6.5% |
| a | 9616 | 5.6% |
| l | 9335 | 5.4% |
| d | 9100 | 5.3% |
| m | 7886 | 4.6% |
| Other values (39) | 44035 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 171847 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 21470 | ||
| i | 18397 | |
| e | 14543 | 8.5% |
| t | 13890 | 8.1% |
| r | 12472 | 7.3% |
| o | 11103 | 6.5% |
| a | 9616 | 5.6% |
| l | 9335 | 5.4% |
| d | 9100 | 5.3% |
| m | 7886 | 4.6% |
| Other values (39) | 44035 |
supplierID
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 53.9 KiB |
supplierNameCode
Text
| Distinct | 309 |
|---|---|
| Distinct (%) | 4.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.9 KiB |
Length
| Max length | 49 |
|---|---|
| Median length | 43 |
| Mean length | 20.548692 |
| Min length | 3 |
Characters and Unicode
| Total characters | 141375 |
|---|---|
| Distinct characters | 57 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 100 ? |
|---|---|
| Unique (%) | 1.5% |
Sample
| 1st row | VIJAY TRANSPORT |
|---|---|
| 2nd row | VJ LOGISTICS |
| 3rd row | G.S. TRANSPORT |
| 4th row | ARVINTH TRANSPORT |
| 5th row | SR TRANSPORTS |
| Value | Count | Frequency (%) |
| logistics | 1208 | 6.0% |
| transport | 1207 | 6.0% |
| private | 955 | 4.8% |
| transports | 877 | 4.4% |
| unknown | 742 | 3.7% |
| a | 708 | 3.5% |
| limited | 705 | 3.5% |
| carriers | 586 | 2.9% |
| s | 544 | 2.7% |
| sunita | 497 | 2.5% |
| Other values (424) | 12062 |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 14575 | 10.3% |
| 13473 | 9.5% | |
| A | 13018 | 9.2% |
| T | 11401 | 8.1% |
| S | 10820 | 7.7% |
| I | 9178 | 6.5% |
| N | 6840 | 4.8% |
| E | 6426 | 4.5% |
| P | 4880 | 3.5% |
| O | 4607 | 3.3% |
| Other values (47) | 46157 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 141375 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| R | 14575 | 10.3% |
| 13473 | 9.5% | |
| A | 13018 | 9.2% |
| T | 11401 | 8.1% |
| S | 10820 | 7.7% |
| I | 9178 | 6.5% |
| N | 6840 | 4.8% |
| E | 6426 | 4.5% |
| P | 4880 | 3.5% |
| O | 4607 | 3.3% |
| Other values (47) | 46157 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 141375 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| R | 14575 | 10.3% |
| 13473 | 9.5% | |
| A | 13018 | 9.2% |
| T | 11401 | 8.1% |
| S | 10820 | 7.7% |
| I | 9178 | 6.5% |
| N | 6840 | 4.8% |
| E | 6426 | 4.5% |
| P | 4880 | 3.5% |
| O | 4607 | 3.3% |
| Other values (47) | 46157 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 141375 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| R | 14575 | 10.3% |
| 13473 | 9.5% | |
| A | 13018 | 9.2% |
| T | 11401 | 8.1% |
| S | 10820 | 7.7% |
| I | 9178 | 6.5% |
| N | 6840 | 4.8% |
| E | 6426 | 4.5% |
| P | 4880 | 3.5% |
| O | 4607 | 3.3% |
| Other values (47) | 46157 |
Material Shipped
Text
| Distinct | 1407 |
|---|---|
| Distinct (%) | 20.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 53.9 KiB |
Length
| Max length | 40 |
|---|---|
| Median length | 35 |
| Mean length | 17.204506 |
| Min length | 3 |
Characters and Unicode
| Total characters | 118367 |
|---|---|
| Distinct characters | 77 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 652 ? |
|---|---|
| Unique (%) | 9.5% |
Sample
| 1st row | BRACKET / GRAB HANDLE |
|---|---|
| 2nd row | ZB MODEL PLATE / 3143 |
| 3rd row | LETTERING / FUSO |
| 4th row | LU STRUT RA / RADIUS ROD |
| 5th row | WISHBONE / V ROD/HDT |
| Value | Count | Frequency (%) |
| parts | 1684 | 8.3% |
| auto | 1516 | 7.4% |
| 1093 | 5.4% | |
| starter | 555 | 2.7% |
| empty | 515 | 2.5% |
| 12v | 441 | 2.2% |
| assy | 426 | 2.1% |
| motor | 396 | 1.9% |
| lu | 307 | 1.5% |
| trays | 266 | 1.3% |
| Other values (1572) | 13200 |
Most occurring characters
| Value | Count | Frequency (%) |
| 13808 | 11.7% | |
| A | 9938 | 8.4% |
| T | 9741 | 8.2% |
| R | 9002 | 7.6% |
| S | 7645 | 6.5% |
| E | 7307 | 6.2% |
| O | 6192 | 5.2% |
| P | 4416 | 3.7% |
| L | 4383 | 3.7% |
| I | 4124 | 3.5% |
| Other values (67) | 41811 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 118367 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 13808 | 11.7% | |
| A | 9938 | 8.4% |
| T | 9741 | 8.2% |
| R | 9002 | 7.6% |
| S | 7645 | 6.5% |
| E | 7307 | 6.2% |
| O | 6192 | 5.2% |
| P | 4416 | 3.7% |
| L | 4383 | 3.7% |
| I | 4124 | 3.5% |
| Other values (67) | 41811 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 118367 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 13808 | 11.7% | |
| A | 9938 | 8.4% |
| T | 9741 | 8.2% |
| R | 9002 | 7.6% |
| S | 7645 | 6.5% |
| E | 7307 | 6.2% |
| O | 6192 | 5.2% |
| P | 4416 | 3.7% |
| L | 4383 | 3.7% |
| I | 4124 | 3.5% |
| Other values (67) | 41811 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 118367 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 13808 | 11.7% | |
| A | 9938 | 8.4% |
| T | 9741 | 8.2% |
| R | 9002 | 7.6% |
| S | 7645 | 6.5% |
| E | 7307 | 6.2% |
| O | 6192 | 5.2% |
| P | 4416 | 3.7% |
| L | 4383 | 3.7% |
| I | 4124 | 3.5% |
| Other values (67) | 41811 |
| Curr_lat | Curr_lon | Driver_MobileNo | GpsProvider | Market/Regular | Minimum_kms_to_be_covered_in_a_day | TRANSPORTATION_DISTANCE_IN_KM | customerID | customerNameCode | vehicleType | |
|---|---|---|---|---|---|---|---|---|---|---|
| Curr_lat | 1.000 | -0.240 | -0.121 | 0.222 | 0.119 | 0.158 | 0.023 | 0.295 | 0.294 | 0.231 |
| Curr_lon | -0.240 | 1.000 | 0.048 | 0.185 | 0.062 | 0.125 | 0.013 | 0.337 | 0.336 | 0.317 |
| Driver_MobileNo | -0.121 | 0.048 | 1.000 | 0.282 | 1.000 | 0.000 | -0.031 | 0.192 | 0.191 | 0.189 |
| GpsProvider | 0.222 | 0.185 | 0.282 | 1.000 | 0.000 | 0.289 | 0.334 | 0.433 | 0.431 | 0.211 |
| Market/Regular | 0.119 | 0.062 | 1.000 | 0.000 | 1.000 | 1.000 | 0.206 | 0.410 | 0.425 | 1.000 |
| Minimum_kms_to_be_covered_in_a_day | 0.158 | 0.125 | 0.000 | 0.289 | 1.000 | 1.000 | 0.361 | 1.000 | 1.000 | 0.707 |
| TRANSPORTATION_DISTANCE_IN_KM | 0.023 | 0.013 | -0.031 | 0.334 | 0.206 | 0.361 | 1.000 | 0.505 | 0.504 | 0.425 |
| customerID | 0.295 | 0.337 | 0.192 | 0.433 | 0.410 | 1.000 | 0.505 | 1.000 | 0.987 | 0.493 |
| customerNameCode | 0.294 | 0.336 | 0.191 | 0.431 | 0.425 | 1.000 | 0.504 | 0.987 | 1.000 | 0.503 |
| vehicleType | 0.231 | 0.317 | 0.189 | 0.211 | 1.000 | 0.707 | 0.425 | 0.493 | 0.503 | 1.000 |
| GpsProvider | BookingID | Market/Regular | BookingID_Date | vehicle_no | Origin_Location | Destination_Location | Org_lat_lon | Des_lat_lon | Data_Ping_time | Planned_ETA | Current_Location | DestinationLocation | actual_eta | Curr_lat | Curr_lon | ontime | delay | OriginLocation_Code | DestinationLocation_Code | trip_start_date | trip_end_date | TRANSPORTATION_DISTANCE_IN_KM | vehicleType | Minimum_kms_to_be_covered_in_a_day | Driver_Name | Driver_MobileNo | customerID | customerNameCode | supplierID | supplierNameCode | Material Shipped | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CONSENT TRACK | MVCV0000927/082021 | Market | 2020-08-17 14:59:01.000 | KA590408 | TVSLSL-PUZHAL-HUB,CHENNAI,TAMIL NADU | ASHOK LEYLAND PLANT 1- HOSUR,HOSUR,KARNATAKA | 13.1550,80.1960 | 12.7400,77.8200 | 2020-08-24 00:05:09 | 2020-08-21 18:59:01 | Vaniyambadi Rd, Valayambattu, Tamil Nadu 635752, India | ASHOK LEYLAND PLANT 1- HOSUR,HOSUR,KARNATAKA | 2020-08-28 14:38:04.447000 | 12.663500 | 78.649870 | NaN | R | CHEPUZTVSHUA1 | HOSHOSALLCCA2 | 2020-08-17 14:59:01 | NaN | 320.0 | NaN | NaN | NaN | NaN | ALLEXCHE45 | Ashok leyland limited | VIJEXHOSR7 | VIJAY TRANSPORT | BRACKET / GRAB HANDLE |
| 1 | VAMOSYS | VCV00014271/082021 | Regular | 2020-08-27 16:22:22.827 | TN30BC5917 | DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU | DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU | 12.8390,79.9540 | 12.8390,79.9540 | 2020-08-28 12:40:28 | 2020-08-31 20:22:22.827000 | Unnamed Road, Oragadam Industrial Corridor, Vattambakkam R.F., Tamil Nadu 631605, India | DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU | 2020-08-28 12:46:17.007000 | 12.836757 | 79.954428 | G | NaN | CHEORADMRCCB1 | CHEMATDMROPA7 | 2020-08-27 16:21:52 | NaN | 103.0 | NaN | NaN | RAMESH | NaN | DMREXCHEUX | Daimler india commercial vehicles pvt lt | VJLEXSHE09 | VJ LOGISTICS | ZB MODEL PLATE / 3143 |
| 2 | CONSENT TRACK | VCV00014382/082021 | Regular | 2020-08-27 17:59:24.987 | TN22AR2748 | LUCAS TVS LTD-PONDY,PONDY,PONDICHERRY | LUCAS TVS LTD-PONDY,PONDY,PONDICHERRY | 11.8710,79.7390 | 11.8710,79.7390 | 2020-08-28 09:05:09 | 2020-08-31 21:59:24.987000 | 570, National Hwy 48, Shenoy Nagar, Chennai, Tamil Nadu 600030, India | LUCAS TVS LTD-PONDY,PONDY,PONDICHERRY | 2020-08-28 16:03:30.793000 | 13.073956 | 80.225780 | G | NaN | CHEPONLUTCCA4 | CHEPONLUTCCA4 | 2020-08-27 17:57:04 | NaN | 300.0 | NaN | NaN | GIRI | NaN | LUTGCCHE06 | Lucas tvs ltd | GSTEXLAK1Q | G.S. TRANSPORT | LETTERING / FUSO |
| 3 | VAMOSYS | VCV00014743/082021 | Regular | 2020-08-28 00:48:24.503 | TN28AQ0781 | DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU | DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU | 12.8390,79.9540 | 12.8390,79.9540 | 2020-08-28 12:40:31 | 2020-09-01 04:48:24.503000 | Singaperumal Koil - Sriperumbudur Rd, Oragadam Industrial Corridor, Vattambakkam R.F., Tamil Nadu 631605, India | DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU | 2020-08-28 12:50:27.997000 | 12.836686 | 79.950560 | G | NaN | CHEORADMRCCB1 | CHEMATDMROPA7 | 2020-08-28 00:47:45 | NaN | 61.0 | NaN | NaN | RAVI | NaN | DMREXCHEUX | Daimler india commercial vehicles pvt lt | ARVEXNAM09 | ARVINTH TRANSPORT | LU STRUT RA / RADIUS ROD |
| 4 | VAMOSYS | VCV00014744/082021 | Regular | 2020-08-28 01:23:19.243 | TN68F1722 | LUCAS TVS LTD-PONDY,PONDY,PONDICHERRY | LUCAS TVS LTD-PONDY,PONDY,PONDICHERRY | 11.8720,79.6320 | 11.8720,79.6320 | 2020-08-28 12:40:29 | 2020-09-01 05:23:19.243000 | Melmaruvathur, Tamil Nadu 603319, India | LUCAS TVS LTD-PONDY,PONDY,PONDICHERRY | 2020-08-28 14:22:50.127000 | 12.429501 | 79.831556 | G | NaN | CHENETLUTCCA1 | CHENETLUTCCA1 | 2020-08-28 01:13:48 | NaN | 240.0 | NaN | NaN | TAMIL | NaN | LUTGCCHE06 | Lucas tvs ltd | SRTEXKOR96 | SR TRANSPORTS | WISHBONE / V ROD/HDT |
| 5 | VAMOSYS | VCV00014749/082021 | Regular | 2020-08-28 02:14:22.640 | TN88A4980 | DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU | DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU | 12.8390,79.9540 | 12.8390,79.9540 | 2020-08-28 12:40:28 | 2020-09-01 06:14:22.640000 | Ind.park Road, Nayapakkam, Tamil Nadu 602105, India | DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU | 2020-08-28 13:25:50.353000 | 13.017365 | 79.962313 | G | NaN | CHEORADMRCCB1 | CHEMATDMROPA7 | 2020-08-28 02:13:39 | NaN | 70.0 | NaN | NaN | GANESH | NaN | DMREXCHEUX | Daimler india commercial vehicles pvt lt | ESWEXNAM02 | ESWAR TRANSPORT | MOUNTING BRACKET / FUEL TANK |
| 6 | VAMOSYS | VCV00014750/082021 | Regular | 2020-08-28 02:20:27.530 | TN88C8204 | DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU | DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU | 12.8390,79.9540 | 12.8390,79.9540 | 2020-08-28 12:40:29 | 2020-09-01 06:20:27.530000 | Rettai Kovil Bus Stop, 64, Salem - Ulundurpettai Hwy, K R Nagar, Seelanaickenpatti, Salem, Tamil Nadu 636006, India | DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU | 2020-08-28 17:38:13.480000 | 11.625962 | 78.157271 | G | NaN | CHEORADMRCCB1 | CHEMATDMROPA7 | 2020-08-28 02:19:47 | NaN | 931.0 | NaN | NaN | SAKTHIVEL.M | NaN | DMREXCHEUX | Daimler india commercial vehicles pvt lt | ESWEXNAM02 | ESWAR TRANSPORT | MOUNTING BRACKET / FUEL TANK |
| 7 | VAMOSYS | VCV00014812/082021 | Regular | 2020-08-28 09:22:31.377 | TN88D4133 | DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU | DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU | 12.8390,79.9540 | 12.8390,79.9540 | 2020-08-28 12:40:28 | 2020-09-01 13:22:31.377000 | Singaperumal Koil - Sriperumbudur Rd, Oragadam Industrial Corridor, Vattambakkam R.F., Tamil Nadu 631605, India | DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU | 2020-08-28 12:49:03.727000 | 12.836837 | 79.951003 | G | NaN | CHEORADMRCCB1 | CHEMTADMROPA1 | 2020-08-28 09:21:56 | NaN | 20.0 | NaN | NaN | SUDHAKAR | NaN | DMREXCHEUX | Daimler india commercial vehicles pvt lt | NSAEXNAMDZ | NAMAKKAL SRI ANJINAYA TRANSPORT | MOUNTING BRACKET / FUEL TANK |
| 8 | CONSENT TRACK | MVCV0001769/082021 | Market | 2020-08-28 09:38:30.000 | TN23AM4662 | ASHOK LEYLAND ENNORE,CHENNAI,TAMIL NADU | ASHOK LEYLAND PLANT 2-HOSUR,HOSUR,KARNATAKA | 13.2150,80.3200 | 12.7660,77.7860 | 2020-08-28 09:00:06 | 2020-09-01 13:38:30 | Mumbai Hwy, Komeswaram, Tamil Nadu 635802, India | ASHOK LEYLAND PLANT 2-HOSUR,HOSUR,KARNATAKA | 2020-08-28 15:00:19.080000 | 12.810470 | 78.740460 | G | NaN | CHEENNALLCCA1 | HOSHOSALLCCA3 | 2020-08-28 09:38:30 | NaN | 310.0 | NaN | NaN | NaN | NaN | ALLEXCHE45 | Ashok leyland limited | VRLEXENN11 | VINAYAKA ROADLINES | MOUNTING BRACKET / FUEL TANK |
| 9 | VAMOSYS | VCV00014665/082021 | Regular | 2020-08-27 22:27:54.427 | TN30BC5982 | DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU | DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU | 12.8390,79.9540 | 12.8390,79.9540 | 2020-08-28 12:40:28 | 2020-09-01 02:27:54.427000 | Unnamed Road, Oragadam Industrial Corridor, Vattambakkam R.F., Tamil Nadu 631605, India | DAIMLER INDIA COMMERCIAL VEHICLES,KANCHIPURAM,TAMIL NADU | 2020-08-28 12:46:20.717000 | 12.837941 | 79.951967 | G | NaN | CHEORADMRCCB1 | CHEMATDMROPA7 | 2020-08-27 22:27:14 | NaN | 103.0 | NaN | NaN | SENTHIL KUMAR | NaN | DMREXCHEUX | Daimler india commercial vehicles pvt lt | VJLEXSHE09 | VJ LOGISTICS | MOUNTING BRACKET / FUEL TANK |
| GpsProvider | BookingID | Market/Regular | BookingID_Date | vehicle_no | Origin_Location | Destination_Location | Org_lat_lon | Des_lat_lon | Data_Ping_time | Planned_ETA | Current_Location | DestinationLocation | actual_eta | Curr_lat | Curr_lon | ontime | delay | OriginLocation_Code | DestinationLocation_Code | trip_start_date | trip_end_date | TRANSPORTATION_DISTANCE_IN_KM | vehicleType | Minimum_kms_to_be_covered_in_a_day | Driver_Name | Driver_MobileNo | customerID | customerNameCode | supplierID | supplierNameCode | Material Shipped | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6870 | JTECH | WDSBKTP43133 | Regular | 2019-03-30 14:55:15 | KA01AF0114 | Mugabala, Bangalore Rural, Karnataka | Kengeri, Bangalore Rural, Karnataka | 12.992699792116747,77.803841411108593 | 12.73017358940589,77.95620203691567 | 2019-06-14 15:20:12 | 2019-03-30 17:17:00 | SGT Goods Shed Rd, Kadugodi, Bengaluru, Karnataka 560067, India | Kengeri, Bangalore Rural, Karnataka | 2019-03-30 16:32:00 | 12.996516 | 77.740759 | G | NaN | VLR00777 | LE005541 | 2019-03-30 15:35:00 | 2019-03-30 16:32:00 | 47.3 | 40 FT 3XL Trailer 35MT | NaN | NaN | NaN | LTLEXMUM40 | Larsen & toubro limited | 55556 | A S TRANSPORTS | BSHG-VLV GID |
| 6871 | JTECH | WDSBKTP42137 | Regular | 2019-03-20 18:57:16 | KA01AF0114 | Mugabala, Bangalore Rural, Karnataka | Anekal, Bangalore, Karnataka | 12.992699792116747,77.803841411108593 | 12.711983972934837,77.69108593367848 | 2019-06-14 15:20:12 | 2019-03-20 20:48:16 | SGT Goods Shed Rd, Kadugodi, Bengaluru, Karnataka 560067, India | Anekal, Bangalore, Karnataka | 2019-06-14 16:57:00.137000 | 12.996516 | 77.740759 | NaN | R | VLR00777 | LE004850 | 2019-03-20 18:57:16 | 2019-06-14 16:57:00.137000 | NaN | 40 FT 3XL Trailer 35MT | NaN | NaN | NaN | LTLEXMUM40 | Larsen & toubro limited | 55556 | A S TRANSPORTS | SWITCH ASSEMBLY RH |
| 6872 | JTECH | WDSBKTP43018 | Regular | 2019-03-29 18:33:01 | KA01AF8395 | Mugabala, Bangalore Rural, Karnataka | Anekal, Bangalore, Karnataka | 16.560192249175344,80.792293091599547 | 12.711983972934837,77.69108593367848 | 2019-06-14 15:20:12 | 2019-03-29 22:12:00 | NH 48, Chikkabennur, Karnataka 577541, India | Anekal, Bangalore, Karnataka | 2019-03-29 21:27:00 | 14.312477 | 76.246717 | G | NaN | V0048673 | LE004850 | 2019-03-29 20:21:00 | 2019-03-29 21:27:00 | 49.0 | 40 FT 3XL Trailer 35MT | NaN | NaN | NaN | LTLEXMUM40 | Larsen & toubro limited | 55556 | A S TRANSPORTS | CONTROL LEVER ASSY L |
| 6873 | JTECH | WDSBKTP42532 | Regular | 2019-03-25 18:20:45 | KA21A6239 | Mugabala, Bangalore Rural, Karnataka | Chikkabidarkal, Bangalore, Karnataka | 16.560192249175344,80.792293091599547 | 12.777874729699617,77.642275537347089 | 2019-06-14 15:20:12 | 2019-03-27 23:09:00 | Shed No 60, Medahalli Kadugodi Road, Virgonagar Industrial Estate, Aavalahalli, Bengaluru, Karnataka 560049, India | Chikkabidarkal, Bangalore, Karnataka | 2019-03-27 22:24:00 | 13.024866 | 77.722378 | G | NaN | V0048673 | LE005179 | 2019-03-27 20:03:00 | 2019-03-27 22:24:00 | 31.0 | 40 FT 3XL Trailer 35MT | NaN | NaN | NaN | LTLEXMUM40 | Larsen & toubro limited | 55556 | A S TRANSPORTS | KILL SWITCH |
| 6874 | JTECH | WDSBKTP45240 | Regular | 2019-04-23 12:32:42 | KA21A6239 | Mugabala, Bangalore Rural, Karnataka | Bangalore International Airport, Bangalore, Karnataka | 16.560192249175344,80.792293091599547 | 13.199089183304451,77.708554234959038 | 2019-06-14 15:20:12 | 2019-04-24 15:40:00 | Shed No 60, Medahalli Kadugodi Road, Virgonagar Industrial Estate, Aavalahalli, Bengaluru, Karnataka 560049, India | Bangalore International Airport, Bangalore, Karnataka | 2019-04-24 14:55:00 | 13.024866 | 77.722378 | G | NaN | V0048673 | LE005770 | 2019-04-24 11:40:00 | 2019-04-24 14:55:00 | 40.0 | 40 FT 3XL Trailer 35MT | NaN | NaN | NaN | LTLEXMUM40 | Larsen & toubro limited | 55556 | A S TRANSPORTS | HORN NP.027 |
| 6875 | JTECH | WDSBKTP42751 | Regular | 2019-03-27 17:25:33 | KA219502 | Ramamurthy Nagar, Bangalore, Karnataka | Sahakaranagar P.O, Bangalore, Karnataka | 13.007503209603689,77.665098855934886 | 13.068901840235711,77.590655738806618 | 2019-06-14 15:20:12 | 2019-03-27 18:31:00 | SGT Goods Shed Rd, Kadugodi, Bengaluru, Karnataka 560067, India | Sahakaranagar P.O, Bangalore, Karnataka | 2019-03-27 17:46:00 | 12.996370 | 77.740616 | G | NaN | V0045771 | LE005870 | 2019-03-27 18:00:00 | 2019-03-27 17:46:00 | 12.0 | 25 FT Open Body 21MT | NaN | NaN | NaN | LTLEXMUM40 | Larsen & toubro limited | 55556 | A S TRANSPORTS | TOOL KIT SET |
| 6876 | JTECH | WDSBKTP43203 | Regular | 2019-03-31 15:02:34 | KA01AE9163 | Ramamurthy Nagar, Bangalore, Karnataka | Bangalore International Airport, Bangalore, Karnataka | 13.007503209603689,77.665098855934886 | 13.196312912801169,77.708156925688726 | 2019-06-14 15:20:12 | 2019-03-31 20:36:00 | Shed No 60, Medahalli Kadugodi Road, Virgonagar Industrial Estate, Aavalahalli, Bengaluru, Karnataka 560049, India | Bangalore International Airport, Bangalore, Karnataka | 2019-03-31 19:51:00 | 13.024788 | 77.722391 | G | NaN | V0045771 | LE005419 | 2019-03-31 17:30:00 | 2019-03-31 19:51:00 | 31.0 | 40 FT 3XL Trailer 35MT | NaN | NaN | NaN | LTLEXMUM40 | Larsen & toubro limited | 55556 | A S TRANSPORTS | CONTROL LEVER ASSY |
| 6877 | JTECH | WDSBKTP43021 | Regular | 2019-03-29 18:56:26 | KA01AE9163 | Mugabala, Bangalore Rural, Karnataka | Anekal, Bangalore, Karnataka | 16.560192249175344,80.792293091599547 | 12.722686,77.676518 | 2019-06-14 15:20:12 | 2019-03-30 01:38:00 | Shed No 60, Medahalli Kadugodi Road, Virgonagar Industrial Estate, Aavalahalli, Bengaluru, Karnataka 560049, India | Anekal, Bangalore, Karnataka | 2019-03-30 00:53:00 | 13.024788 | 77.722391 | G | NaN | V0048673 | LE005848 | 2019-03-29 20:44:00 | 2019-03-30 00:53:00 | 49.0 | 40 FT 3XL Trailer 35MT | NaN | NaN | NaN | LTLEXMUM40 | Larsen & toubro limited | 55556 | A S TRANSPORTS | SPARE PARTS AUTOMOBILE |
| 6878 | JTECH | WDSBKTP42685 | Regular | 2019-03-27 08:29:45 | KA21A3643 | Mugabala, Bangalore Rural, Karnataka | Anekal, Bangalore, Karnataka | 16.560192249175344,80.792293091599547 | 12.896896847817695,77.712223056874862 | 2019-06-14 15:20:12 | 2019-03-27 17:20:00 | Shed No 60, Medahalli Kadugodi Road, Virgonagar Industrial Estate, Aavalahalli, Bengaluru, Karnataka 560049, India | Anekal, Bangalore, Karnataka | 2019-03-27 16:35:00 | 13.024747 | 77.721823 | NaN | R | V0048673 | LEL04580 | 2019-03-27 15:29:00 | 2019-03-27 16:35:00 | 49.0 | 40 FT 3XL Trailer 35MT | NaN | NaN | NaN | LTLEXMUM40 | Larsen & toubro limited | 55556 | A S TRANSPORTS | SPARE PARTS AUTOMOBILE |
| 6879 | JTECH | WDSBKTP42858 | Regular | 2019-03-28 17:55:17 | KA51D1317 | Mugabala, Bangalore Rural, Karnataka | Anekal, Bangalore, Karnataka | 16.560192249175344,80.792293091599547 | 13.199089183304451,77.708554234959038 | 2019-06-14 15:20:12 | 2019-03-29 00:26:00 | 20/1, Sulthangunta, Shivaji Nagar, Bengaluru, Karnataka 560051, India | Anekal, Bangalore, Karnataka | 2019-03-28 23:41:00 | 12.991815 | 77.606038 | G | NaN | V0048673 | LE005770 | 2019-03-28 20:26:00 | 2019-03-28 23:41:00 | 49.0 | 40 FT 3XL Trailer 35MT | NaN | NaN | NaN | LTLEXMUM40 | Larsen & toubro limited | 55556 | A S TRANSPORTS | SPARE PARTS AUTOMOBILE |